Technical comparison of operations

Import Dataset

.NET Wrapper Source

Import

No

0

n/a

Yes

Software

Low

Import from a .NET Wrapper Source

Import Dataset

Database Table

Import

No

0

n/a

Yes

None

High

Import table data

Import Dataset

Proficy Historian

Import

No

0

n/a

Yes

None

High

Import from a Proficy Source

Import Dataset

Proficy Historian A&E

Import

No

0

n/a

Yes

None

High

Import Alarms and Events from a Proficy Source

Import Dataset

Random Values

Import

No

0

n/a

Yes

None

High

Generate random Data

Import Dataset

Source Block

Import

No

0

n/a

Yes

Software

High

Architect Source block

Import Dataset

Text File

Import

No

0

n/a

Yes

None

High

Imports data from a delimited text file

Import Dataset

Wave Generator

Import

No

0

n/a

Yes

None

High

Generates different types of waves

Add Fields

.NET Expression

Modify

Yes

1

No

Yes

.NET

High

Create a new field from a .NET expression

Add Fields

.NET Script

Modify

Yes

1

No

Yes

.NET

High

Create new fields from a C# or VB.NET script

Add Fields

Classify

Modify

Yes

1

No

No

None

Medium

Assigns classes over certain ranges within fields

Add Fields

Concatenate

Modify

Yes

1

No

No

None

Low

String concatenation

Add Fields

Copy

Modify

Yes

1

No

No

None

Low

Copy fields

Add Fields

MATLAB .NET Assembly

Modify

Yes

1

No

No

MATLAB

High

MATLAB outputs fields are added to the dataset

Add Fields

Rate Of Change

Modify

Yes

1

No

No

Software

High

Rate of change

Add Fields

Shift Values

Modify

Yes

1

No

No

None

Low

Create offset fields

Add Fields

SQL Expression

Modify

Yes

1

No

No

SQL

Low

Create your own SQL expressions

Remove

Delete Fields

Modify

Yes

1

No

No

None

Low

Delete selected fields

Modify Dataset

Clip Values

Modify

Yes

1

No

Yes

.NET

Low

Clipping

Modify Dataset

Detect Inactivity

Modify

Yes

1

No

No

Software

High

Detect inactivity

Modify Dataset

Interpolate Empty Values

Modify

Yes

1

No

No

Software

High

Interpolation

Modify Dataset

Rename Fields

Modify

Yes

1

No

Yes

None

Low

Rename fields

Modify Dataset

Replace Empty Values

Modify

Yes

1

No

Yes

None

Low

Fills the null values with the previous or next value

Modify Dataset

Replace Partial Strings

Modify

Yes

1

No

No

None

Low

Find and replace Strings

Modify Dataset

Replace Strings

Modify

Yes

1

No

No

None

Low

Replace String fields

Modify Dataset

Scale Values

Modify

Yes

1

No

No

None

Low

Scale fields

Modify Dataset

SQL Update

Modify

Yes

1

No

No

SQL

Low

Update values using SQL code

Modify Dataset

Time Manipulation

Modify

Yes

1

No

No

Software

High

Time manipulation

Transform Dataset

Aggregate

Create

Yes

1

Yes

No

None

Low

Aggregate fields

Transform Dataset

Convert Types

Create

Yes

1

Yes

No

None

High

Converts from one data type to another data type

Transform Dataset

Copy

Create

Yes

1

Yes

n/a

None

Low

Copy the dataset

Transform Dataset

Correlation

Create

Yes

1

Yes

No

Software

High

Correlation

Transform Dataset

Cross Correlation

Create

Yes

1

Yes

No

Software

Medium

Auto lag fields

Transform Dataset

Delay

Create

Yes

1

Yes

No

Software

High

Delay

Transform Dataset

ISV Action Object

Create

Yes

1

Yes

No

Software

High

ISV Operation

Transform Dataset

Join Timestamps

Create

Yes

1

Yes

No

Software

High

Join timestamp fields

Transform Dataset

Moving Statistics

Create

Yes

1

Yes

Yes

Software

Low

Calculates moving statistics for the selected fields

Transform Dataset

Resample

Create

Yes

1

Yes

No

Software

High

Resample

Transform Dataset

Reverse

Create

Yes

1

Yes

n/a

None

Low

Reverses the order of the values in the dataset

Transform Dataset

Sort

Create

Yes

1

Yes

No

None

Low

Sort fields in ascending or descending order

Transform Dataset

Statistics

Create

Yes

1

Yes

No

Software

Low

Calculates statistics for the selected fields

Transform Dataset

Transpose

Create

Yes

1

Yes

No

None

Low

Transpose fields

Filter Dataset

Empty Values

Create

Yes

1

Yes

No

None

Low

Filter null fields

Filter Dataset

Limit Values

Create

Yes

1

Yes

Yes

None

Low

Filter fields within user defined limits

Filter Dataset

SQL Expression

Create

Yes

1

Yes

No

SQL

Low

Filter values using SQL code

Filter Dataset

Timestamps

Create

Yes

1

Yes

No

None

Low

Filter timestamps within user defined limits

Combine Dataset

Horizontal

Create

Yes

2

Yes

No

None

Low

Merge tables horizontally on row numbers

Combine Dataset

Relational

Create

Yes

2

Yes

No

None

Medium

Merge tables on chosen fields

Combine Dataset

Time

Create

Yes

2

Yes

No

Software

High

Time merge

Combine Dataset

Timestamp Range Merge

Create

Yes

2

Yes

No

Software

High

Data merge within a timestamp range

Combine Dataset

Vertical

Create

Yes

2

Yes

No

None

Low

Merge tables vertically

Export Dataset

.NET Wrapper

Export

Yes

1

Yes

Yes

Software

High

Export to a .NET Wrapper Sink

Export Dataset

Sink Block

Export

Yes

1

Yes

Yes

Software

High

Export to a Architect Sink block

Export Dataset

Text File

Export

Yes

1

Yes

Yes

None

Medium

Export the dataset to text file